SQLAlchemy for Python Developers

# Tutorial Overview


# Overview

SQLAlchemy is a library in Python that facilitates the connection to databases and the use of ORM (Object-Relational Mapping).
For instance, you can execute specific queries in your code and perform a series of operations in the database through ORM objects.


# Installation

SQLAlchemy can be installed as follows:

$ pip install sqlalchemy

The version being used is as follows:

>>> import sqlalchemy
>>> sqlalchemy.__version__  
1.4.20

# Offerings

SQLAlchemy is offered in the following two ways:

  • Core
    • This is the database toolkit and the foundational architecture of SQLAlchemy.
    • It manages connections to databases, interacts with database queries and results, and provides tools to programmatically compose SQL statements.
  • ORM
    • Built on top of Core, it provides optional ORM (Object-Relational Mapping) features.

It is generally recommended to understand Core first before using ORM.
This tutorial will start by explaining Core.

Setting up a Connection →